SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DISC_DefaultStampConfigAdd]
   @distID varchar(50),
   @name nvarchar(50),
   @description ntext,
   @publisherName nvarchar(50),
   @staticString nvarchar(150),
   @pages nvarchar(max),
   @fontName varchar(50),
   @fontSize float,
   @textRenderingMode tinyint,
   @textColor varchar(6),
   @textStrokeColor varchar(6),
   @strokeWidth float,
   @placeAs int,
   @x varchar(6),
   @y varchar(6),
   @units tinyint,
   @rotate int,
   @opacity tinyint,
   @fontEmbed bit,
   @fontSubset bit,
   @stampType tinyint,
   @textColorSpace tinyint,
   @strokeColorSpace tinyint
AS
BEGIN
	INSERT INTO [DISC_DefaultStampConfig] ([PublisherName], [distID], [staticString], [pages], [fontName],
		[fontSize], [textRenderingMode], [textColor], [textStrokeColor], [strokeWidth], [placeAs],
		[x], [y], [units], [rotate], [opacity], [fontEmbed], [fontSubset], [stampType], [textColorSpace],
		[strokeColorSpace], [Name], [Description])
    VALUES
		(@publisherName, @distID, @staticString, @pages, @fontName,
		@fontSize, @textRenderingMode, @textColor, @textStrokeColor, @strokeWidth, @placeAs, 
		@x, @y, @units, @rotate, @opacity, @fontEmbed, @fontSubset, @stampType, @textColorSpace, 
		@strokeColorSpace, @name, @description)

	SELECT scope_identity()
END
GO
